could this be connected to the pipe on the backside of the dam and accomplished the same thing? then you wouldn't be losing fertile surface water, but pulling less desirable water from below?
No, it's designed for the outflow pipe (water holding side of the dam). You should search the forum for 'siphon systems' which is what I think you're thinking of..
