Mains on private property are usuallly galvanized steel,copper,or pvc. 

The city or your water company,provides water to your property . Usually there is a meter set in a plastic or concrete box near the edge of your property ,where the water providers piping ends. Piping beyond the water meter is the property owners responsibility.The pipe between the meter and the house is called the domestic water main.