Hey, there are lot of resources in the forum and AUM Magazine, its a good idea do some searches in the forum before posting.
If you have 3DGS take a look on water room in the techdemo, but there are others that i dont remember in the moment.
You have to handle with textures offset u,v...