There is no magic water.
Extract or all-grain?
For extract, just about any water will work. Relatively low-mineral water is ideal.
For all-grain, you'll want water that you can predictably reach 1) proper mash pH and 2) overall levels for good yeast health, flocculation, and appropriate for...