Municipal water systems are usually excellent sources of water. Their major drawback is the cost of the water. If you plan to use a municipal water source, plan on installing an irrigation water meter. The water charge is usually the same as the household meter, but there are no sewer charges on the irrigation water since this water is not returned to the municipal sewer system. Some type of backflow prevention device at the meter to protect the water supply will be required by the municipality.
Ponds also work quite well as irrigation sources.
Also, if you plan to use drip irrigation, you will need to provide good filtration for the pond water. Just as a race car driver on the outside corner has more ground to cover than a driver on the inside corner, a sprinkler's stream has to cover more ground as it gets farther away from the sprinkler head. This means that more water is applied near the sprinkler, with less applied as the distance from the sprinkler increases. Obviously, if we place one sprinkler on the ground alone and operate it, we will have a green area right around the sprinkler with plenty of water and then progressively lighter shades of green as we move away from the sprinkler until we get to the brown area near the edge of the sprinkler's throw. Proper initial design will certainly prevent many later problems and headaches.