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.