What type of pipe that is used varies a lot from one area to another.
Here in Florida, the most common type of pipe used in new homes is CPVC, a rigid plastic pipe. Next most common is PEX, a flexible plastic pipe. Occasionally we use copper, but the water around here is usually very corrosive, and eats up copper rather soon. There is one other type of flexible plastic pipe, called Aquatherm, but I have no experience with it. No one uses it anymore, but it is allowed to use galvanized steel pipe.
Outside, the most common pipe is PVC, but we can also use copper, HDPE, PE, CPVC, PEX, or galvanized.