If tap water is not good for a goldfish what type of water is?

Tap water is perfectly OK for goldfish. All you need to do is make sure the added chlorine/chloramine is either chemically removed using a chemical additive available at petshops or if your water provider does not use chloramine all you need to do is let the water stand in a bucket for a few hours or overnight and the chlorine will evaporate off.