I've been thinking about doing this for awhile but couldn't find clear piping.
But I think you could use black or white pvc with holes cut into the side facing the room. Then silicone on windows cut from the center sections of 1 liter plastic Pepsi bottles. It would not have to be very strong to hold the pressure of a few inches of water. And if I understand this correctly, the suction of water trying to escape by gravity would pull on and seal the windows mounted to the outside of the pipe.
It would look more industrial than pretty. But you could cover the pipe with anything and leave the windows exposed.
This would be cheap cheap. It just has to hold the water from pushing out until the elbow openings are turned upside down and the suction comes into play.
I'm sure it would work. Easy to test though. Just set it up outside in two buckets. If it holds for a week or so, move it inside.