Well, my opinion is, having the weight up high isn't too good. As well that this mass will only heat the top part of the house. Plus, you'd have to leave an opening in the tank, so you would get steam in the house. And you would have to have a refill pipe, with a mechanism like the one of toilets. Another problem is that the water only stores heat to 100C° (even less depending on altitude!) And you always have the risk of legionella!
Far too much risks and problems imho.
While a barrel or metal radiator around the heat riser, would heat up the top of the house via convection rather nicely; you could always add a bit of mass to the surounding walls etc up there to keep the heat. And with a nice mass or bell, you'd keep some slow release heat for the bottom of the house. And thoses don't have temperature limitations or spilage problems