Not sure if they work in game as I haven't tested them yet, but there are activator water objects (WorldObjects/Activator.....all the way to the bottom of the list)) that show up okay in the CK. Otherwise, your cell has to be set up to have water in it and some other steps taken to set a water level in your cell. It's been a long time since I did that and I forget how.