hot water is not the best idea, since water start to steam near 150, but anything near 100 (like a hot tub) won't stream for very long.
smoke machines are good for this kind of effect but you could also rig up something with dry ice, but that might give you more of a dry ice look than smoke. you're situation is unusual and rather difficult. i might try the smoke thing, or go for something different.