I have seen it done in many NS maps where there is steam shooting from a vent or a pipe.
I just cant figure out how on earth to get it to work...
The closest i got was using an env_sprite, but that just puffs and isnt really the effect im looking for...