There's a few good places... But depends on what live bands are playing.... I live in Edinburgh but places I go include :
Box, nice n sleazys, firewater, garage, king tuts...
Nearer central you have solid rock (not sure about live music) classic grand, cathouse. Maggie mays.
Hope that helps?