Water is one of the trickiest materials to handle; being such it took a great deal of research and tinkering to get the shader looking proper, but I'm very happy with how it turned out. The terrain for this scene was generated using World Machine and Autodesk Maya. The shader network shown below was developed using UDK's node based shader editor.