Unfortunately, marriage counseling is a complete waste of time if he is still actively using. Don't bother spending the money on it. Nothing you can do will change him or improve your marriage. The only thing you can do is accept him for who he is and learn to detach, since you have indicated you don't want to leave.