If you can afford RealFlow, go for it. But it isn't necessary to get some nice looking water effects. nParticles can do a nice job as well.

See: https://area.autodesk.com/blogs/dunca...ith_nparticles

To make it look better, increase the number of particles, decrease their radii, and play with the meshing settings.