Like Urban above, for me pie & Ale was the best place in town imo but it no longer exists.
My recommendation (if determined to watch it in town) would be Footage on Oxford Road. Less likely to be full of rag scroats as it tends to get more students than anything going in.
If I wasn't...