
Step 1
Make an object that looks similar to this. It has to loop well and not look like a repeating pattern. Also change the Object to Marching Cubes (The purple square is my cursor)

Step 2
Make the object Semi transparent a little less then fully opaque about 70% opaque.
Step 3
Make a tile that has a Floor layer and a Transparent water surface layer above. you should also change the Surface level bar to be at the surface or higher. Make the Water color almost fully Opaque but still slightly transparent.


Step 4
add an Attach point inbetween the water layer and the layer below. Dont X.5 instead just use X.

Step 5
add the Object to the attach point and make its size X1 Y1 Z0.01.

Step 6
make 16 Frames each changing the objects X value by 1. Alone this will look weird but in a Group it will look great.


Animated results!
If you want furthur help leave a comment and I will respond as soon as possible.