First of all, what a blessing you are to your friend to have the kind of care that values the ultimate good of your friend!!
I would call this friend and try to arrange an activity that you both enjoy that doesn't involove drinking. I would go with another friend of yours to your twice monthly hang out that way you will hang out with your other friend and not this person you don't wan to encourage. Keep us posted!!