Much of it depends on you water heating & storage system, age of your residential distribution system, plenty of variables. The most common system in the US is a free standing gas or electric water heater & storage tank unit. These are generally safe to use, provided you do the proper maintenance on them. This means shutting it down at least every 6 months & draining. Any mineral deposits or debris from plumbing aging are removed this way, along with remnants of the sacrificial anode, a component designed to corrode, preventing corrosion of the tank itself. Draining it also extends the life of your water heater, as well as making it run more efficiently. Do your maintenance & these are rarely a problem.
On demand tankless water heaters have no storage tank involved, so avoid the issues associated with that. Endless supply of hot water, but a pricey unit. They make up for the purchase price by being cheaper to run; no large amount of water to keep heated. I have yet to hear of any issues with these, folks with larger fishrooms will often install them. It's a consideration for the next time I change my heater.
Dwellings that are heated with a boiler system will often draw hot water off this system. The problem here is that for heating the same water is constantly heated, cooled down, and recirculated for heating. It picks up dissolved substances from being constantly recirculated in the heating system. Drawing off this for water changes can cause issues with hardness & TDS. Once again, seasonal maintenance will help to minimize this.
Some older systems, mainly found in the UK, will have a storage tank in the loft or attic, often open topped, gravity fed hot water. Being open, and in an unfinished attic, spiders, birds, you name it can fall in. Probably the worst choice for water changes, and for general use.
I ran H&C to the fishroom for a reason, having a 50 gallon gas fired hot water heater it has caused no problems with a wide variety of species. Hooking up a hose to drain it is no issue, as if I don't have enough hoses around. It's about 12 years old, getting near the end of it's usefulness, with the kids moved out tankless would pay for itself in several years.