I hope so.
Just the thought of seeing scratchy Argonian scooma-heads running around cities is kind of entertaining.
May the Hist Guide you.
Farts-With-Purpose
It would be cool but I'm sure ZOS will discourage it. Based on their current description of Moon Sugar, they don't even want people to know its a drug. People who have never played TES before are going to end up thinking its just candy.
Would love to see an underground narcotics trade in ESO with guards that search you like in SWG! That would be amazing, but I'm sure it would be tough for them to get anything below an M rating (which it would be nice for them to have anyway) with something like that in the game.
Skooma is illegal in the Elder Scrolls world, isn't it? Even if its in the game and you're able to make/sell it, I don't think you'd see it hanging around in the local market.