No - won't be NAAFI; more likely partnered with a suitable local 'service provider'.
Cue local employment descrimination for SP Spouses; Friday afternoon/Monday morning convoys to Glasgow Airport and Glasgow Station; schooling issues from Southern (=English children); development of a 'Scottish' Navy; grim housing schemes outside the wire; Thatcher 'victim' mentality...
...so no change then!