Here's a smaller scale water battery that heats an entire house year round. The water tank itself is placed in the center of the house across all 3 floors and actually makes for a quite nice design element as well. The energy is generated in the warm seasons and the volume of water is large enough to last through the entire winter. It's a German vid but subtitles are quite accurate.
Doesn't this suffer the problem that you're then putting heat into the device, which is in your house, during the warm season when you want your house to stay cool?
Think of the water tank as being in but insulated from the house.
In the hot summer the hot air within the house is cooled by heat pumping the heat into the water tank which is slowly over weeks bought up from cold to mean summer tempreture.
In the winter the heat is extracted from the water and transfered to the house.
The house and the water mass are out of phase by six months.
https://www.youtube.com/watch?v=MBLiNHsod8Y