Hi and welcome jimmymac
I was a bar band musician for years - eventually tho my inability to say no to a drink meant I was playing more and more often more and more drunk.
I lost so many gigs, noone would hire me on the end. I was unemployable.
I went back to music a few years into my recovery.
Nowadays I'm a pretty busy muso again - not so much bars anymore but I am around people drinking and smoking whatever, and it doesn't tempt me or put me off, or even register most of the time.
It took a lot of work to get there - but I'm there for the music now.
There's a lot of musos live clean and sober - Clapton, Joe Walsh, Alice Cooper...and many on my local bar scene too, so it's possible.
Many of those guys use AA - have you considered something like that?
D