They included Skooma Pipes and Skooma as a drug and booze, but only NPCs are smoking or drinking it. I just think it would be hliarious to have visual effects of being drunk and going out to kill dremora while intoxicated. Not only do you get the effects on your stats, but you should get the visual effects as well. Imagine Dagoth Ur defeated by the Balmora Town Drunk
O that's Hul isn't it?