best way to make a waterfall mist/foam

i wish to realize something similiar to the beautiful waterfalls you can see in vivec, in morrowind game.

i cannot use glsl. i tried with animated textures (with tiles) but what i’ve done is really ridiculous.

a long time ago i’ve found a tutorial and an example with a fountain in a garden doing it, it was a tutorial about sun glow i think, but i cannot find it anymore. can anyone of you help me (and excuse me for my poor english)?