Helensburgh residents living next to nuclear submarines find rising tensions ‘worrying’, but hope upgrades at Faslane can bring an economic boost