However, your water material seems to work well. The reason it doesn't look like water is because it's vertical.
Water waves will only appear on horizontal / non-vertical surfaces. Try it, apply the same material to a horizontal surface and it will behave just fine.