What a water success!

Finally, after spending ages on trying to figure out how to give the water some 3 dimensional life apart from a flat normal map, I've done it. I had some help from KazeoHin and Scruffy from the UDK forum and they helped me with the WorldPositionOffset node, which offsets the material in 3D space but keeps the object stationary.

It's still not finished though, it is too transparent in some places and it has no "coast" line. But, I'm very happy with the progress and I'll be adapting this for my FMP extra map.

Edit: New version up which has fixed the transparancy issues, I still need to add the mini-coast line and maybe change the colour, it all depends on the final surrounding.