To me the fun puzzle is to lift part of the water above the source without moving parts. One can easily do that with a mech. pump but how to make it solidstate?
Well, I suppose you mean: with the only moving part being the water itself. A hydraulic ram can move water uphill easily without any external power, electricity, etc., using basically only simple valves. If I could build a hydraulic ram of ice, does that count?