For real ale definitely try the Tam O'Shanter on Queensberry Street, The Ship Inn on St.Michaels street, The Caven's Arms on Buccleuch St. and the New Bazzar on the Whitesands. The Bazzar is always full of Queens fans pre match as well.
Saturday nights are always busy. For later on I'd recommend Broon's and the Queensberry both on English street if cask ale is
essential. If not then Greens on St.Michael's street is also worth a visit as is the Hole I' The Wa on the High street . I wouldn't recommend any of the night clubs unless your very inebriated!