Call the cops during one of their little parties when he's letting his daughters' friends get drunk. It may be legal to give your own child alcohol, but I'm positive it's not okay to give it to her underage friends. He'll get busted as the enabler.
I have no sympathy for a guy like your "uncle". Do what you need to to get him out. Like others have said, call the cops when you know he's going to get drugs. Have them ready and waiting for him at your house. Call in a stolen vehicle report. I dunno how things work in Canada, but I'm pretty sure drugs and grand theft auto aren't legal there.