Lots of good points above. I would just add that old water heaters often have weak spots, and are notorious for blowing out and causing basement floods. So I wouldn't keep them under constant pressure from the mains. Your insurance company will probably laugh at you if you try to make a claim.