What most of us ignore is that people have to want to help themselves. Otherwise, their lives will never permanently improve. And unfortunately, this desire doesn't usually happen until people hit bottom. Simple human nature.
If he doesn't want to help himself I see only 2 options then, either A) cut him off of all services and let him hit bottom to the point where he will want help or B) go to prison, get out and get better himself (if not, repeat)