First, I'd want you to tell me about the issue (if I wasn't aware of it already). Have you told your boss? What was his reaction?
Second, after I was told, to be quite candid, I'd be put in a tough position. If this guy is getting loaded at work, people know about it to the point where they're giving him rides, IANAL but that's a huge liability. He does something while drunk and that's coming back on the company. And the problem isn't that I'm a greedy asshole who doesn't want to get sued, it's that if I get sued then you and probably a few other people are going to lose their jobs. Depending on the size of the company a suit could destroy it.
Third, all those things considered, I have to intervene to protect this fellow, you and your colleagues and the company. That doesn't mean fire someone, that means a serious come to Jesus with this guy with the goal being to find a way to get him through this. Underwrite counseling/rehab/whatever is needed.
So...lots of words to get to this: you gotta go up the chain. This isn't your responsibility, unless you are the boss.