Going to bars with live bands, etc. was also one of my favorite things. Personally, there's no way I could go to a place like that anytime soon and stay sober. If the live music is something that you really enjoy when your sober, try finding an outdoor concert. Maybe if your outside with really long beer lines to wait in (and their always long lines) you will not drink. I'll bet most of the people you see in these clubs wish they had your strength to not drink and or use.
If you feel that you will not be strong enough to say no to yourself, then it's probably a good sign not to go. I know there's no way I can go inside any bar right now to listen to music. My sobriety is much more important.
Stay strong and stay clean
Scott