Hot water is not the best idea, since water starts to steam near 150, but anything near 100 (like a hot tub) won't steam 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. Your situation is unusual and rather difficult. I might try the smoke thing, or go for something different.