Waste product

Someone who is useless due to the habitual consumption of drugs and/or alcohol.

Bob is such a waste product, he can’t hold down a job because he’s always wasted.