There are many ways to do this.

You can create a block in WED and apply a water texture to it [there are a few in the standard WAD]. To make it transparent, you must save it seperatly in another WMP file, compile it, and then import it into your level.

Use a skycube/sphere

Use a terrain or model

etc...