pH of 7.0 is "neutral" and for general fishkeeping purposes, should be maintained at that pH or as close to it as possible. However, as the previous post mentions, certain fish require specific pH of varying ranges. Neon tetras (for instance) like more acidic pH, and some fish require pH in the alkaline range.
You just want to make sure that when you add water, the pH is close to what is already in the tank to avoid sudden changes (of temperature and pH especially.)