It's called pumped storage. It exists, but only at larger scales than a household system. It's ~80 efficient.

http://en.wikipedia.org/wiki/Pumped-storage_hydroelectricity