If it's a job you intend to stay in for a while you should move to Stirling. It's a nice place to live. There's not so much choice in terms of food and drink but it's worth it just for the Settle Inn.
Stay within the Royal Burgh and you get free entry to the castle too.