Yes, the efficiency would be pretty good. The problem is that you would need to store a lot of water, and there are not many places where much water can be stored in an elevated position. The day/night cycle would be very difficult, the summer/winter cycle is hopeless.
How about in a lake?