As far as training and location goes Cumbernauld looks great, being in a central location to the whole of Scotland. I wouldn't call it "agricultural" atall- whatever that means.
I've heard great things about both the Perth and Cumbernauld sectors of Leading Edge, both of which have just taken delivery of some very nice Archer III's with autopilot etc I believe...and I've been told their aircraft availiability is great as they have quite a few Cessna's that are shared between both Perth and Cumbernauld.
Go have a look around them all and see which one you like best !