What about dry ice? The stuff they use in theatre pantomimes. Non-toxic and provides an air of mystery and magic.

I know what you mean by atmosphere. In the black-and-white video of the Pogues 'Fairytale of New York', the Irish musicians are smoking fit to bust. It seems to fit with the sleazy lyrics of the song.