Ignoring moderate inefficiencies, storing energy by lifting stuff requires 100 kg-m per kilowatt-second. Choosing a numerically convenient tower height of 36 m, the amount of water required is 10 tonnes per kW-hr.
Choosing some round numbers, a small town might consume 10 MW; at this power delivery rate, a 10 hr energy-storage buffer would require a million tonnes lifted 36 meters. A million tons is about 10 times the mass of this nuclear-powered, Nimitz-class aircraft carrier:
BTW, the U.S. is now fitting out the USS George H. W. Bush, the tenth of this class. Words and ideas I offer here may be used freely and without attribution.