Gravity is never going away and never going to run out.
More details: http://physics.ucsd.edu/do-the-math/2011/11/pump-up-the-stor...
I'm sure there are a bunch of interesting tradeoffs between using water or a bunch of rocks though.
Gravity is never going away and never going to run out.