It could be possible to animate an object with a water texture using a script, but that's not how the game does the water. The editor automatically has water on a specific level in the game, so once you lower your terrain low enough, you'll start seeing animated water. You can set the water texture in the floor toolset.