While I would not want to run everything off it, given the value of the livestock in a tank, an automotive size lipo battery and a sine wave inverter would probably run a tank for a decent amount of time. IF you don't have to run a heater much...
But the real issue is not really hours but days. If you had to run 1000 watts of heaters, you are looking at over 2.5kwh per day. At that point, the price does add up quickly. The cheapest I have seen 5kwh of batteries is close to $1k - and you would still need $500-800 worth of other equipment to make that into a backup.
2 of the last 3 years I have had multi day blackouts during the winter (which is why I worry about keeping heaters on for extended periods of time - my house is going to get cold, we don't have natural gas as an option for heating). On the plus side, they were rolling blackouts - so I could get 15 minutes worth of charging done every 3 hours. Likewise, I could run an extension cord through a window and do short charging spurts off a portable generator. At least it is always fairly easy to heat an aquarium if you have electricity - my heat pumps have also failed me several times in the last 2 years during freezes. Now for outages during the summer. Honestly I have not researched just how much cooling you can get from a fan and evaporation. It might be a low watt way to keep an aquarium from boiling.