Yep, but they all have a limited transparency from what I saw.

So, should your terrain be too deep/the water sheet too high above the terrain, the material will obscure it.