Hard water is actually one of the worst things you can give to expensive house plants, distilled water is by far the best option to prevent root calcification and ph swings.
Amateur hydroponic growers often use reverse osmosis water, somewhat wasteful but cheaper than distilled. You can get RO systems designed for aquarium use with no pressure tank at the output and just let them slowly fill a barrel or tote, over hours or days.