Water is one of the simplest effects to make.

Create a sector and tag it [0,1]. Texture the floor with water (#336). If you want the water to look like sewage, change the water's palette to 8.

Note: Using the water texture isn't required for this effect to work. You can replace it with any texture you want.