As mentioned in the video and also in the product text, the water is just a shader, so no tiles are used for the water. The shader is not included. You can find some ripple Effects however, as you already mentioned.
Thank you very much. Good luck with your project!
