[rincewind]

I think Realflow uses particles for the simulation, then exports a polygon object sequence for the water back to lightwave. You just surface this object to look like water.

There's a discussion on cgtalk about different ways of creating water here