Well I dont even think that you can actually model water allready sounds stupid when writing. You can't model something liquid out of blocks.
So I guess its pretty hard to model water.
My only idea would be that you take something like a smooth curve or something like that and put an animated skin on it but I dont even know if THAT is possible.
regards
Aztec