There are some assets for making a waterfall mist effects. Also there are some assets you can add to water mist or steam effects to rapids. Waterfall Top Plume KUID2:31293:23016:1 by JFE I had to play with the parameters in the config file to make it work for my volcano effect. The asset looks like a small triangle and is invisible in driver.
Jack