Thanks for coming to SR for help DMB. I'd echo others' comments in that you need to find help for yourself above and beyond anything else. Good move on going to see a counselor, do you think total sobriety is going to be your goal? I finally found that was the only way for me, moderation never worked after many attempts.
Regarding your friend, as much as you are trying to help at some point you have to let them help themselves. No matter what you do, your friend won't quit his addiction until he decides to. So literally, turning your back an him might be exactly what you need to do although it seems like exactly the opposite of what you think is right.