I do not know any easier method, than what Mark suggested. Use real water prop, setup desired water type, color and other settings and then render it from the top.
Set nice HDRI sky for interesting water reflections. But do not render with overly large resolution. iClone would choke when you apply such a video into diffuse channel.
You can also make and render water in Blender. Lots of tuts on YouTube such as this one:
https://www.youtube.com/watch?v=fmW8wOkKwecBut I think the default ones are pretty good too. You can mix and match between Color, Bump and Blend channels to get various effects.
You can also add a *real* water movement with Displacement channel. There are couple of bugs with Displacement channel though:
1. You may not change the Tessellation level while video is loaded into Displacement channel.
You need to load any image into Displacement channel, scroll down, change the Tessellation level to some high value and then load a video into Displacement channel
2. Video for the Displacement channel does not appear on the timeline. So it may not be replicated over the time like for the other channels (Color, Bump, Blend)
Anyway, just need to play around with it a lot to get a decent result.