The UK should just retain ownership of the base,or take a long term lease like we did at Guantanamo Bay.
The Scots are not going to want to lose 6,700 good jobs.
Well, we could keep the base and hold it, and military there'd be jack shit the iScots could do about it. Politically of course, it would be impossible, and if we tried, you'd probably get Scots Americans going round Scottish cultural events and bars with 'Brits oot o'Scotland' leaflets in the US raising money for car bombs to go off in English cities for years to come...