We have a solar (parabolic vacuum pipes) water heater which provides 95% of our annual hot water needs, backed up by gas. The heat is stored in a layered and heavily insulated 300 liter tank. The water delivered to the tap isn't actually from the tank, but it's just fresh water heated instantly and on-demand through a heat exchanger which is part of the storage tank. No need to worry about stale hot water with such a system.