Particle generators like this have been used in Hollywood for quite awhile, I bet you would have never have guessed it was CGI though.
Of course, you do have the problem of what to do when the water sim uses up all the available GPU compute power and bandwidth - not much left to render, in that case...