Copper or Pex water pipe?
Copper or Pex pipe both have their benefits, New Pex A type is the best and is very flexible and affordable for in house use. Copper for non freeze areas is ideal for outside because of its heat and durable resistance in the hot climates.
Never, Never and Never use CPVC, major issues with this material, stay away from it, it becomes brittle and breaks. Especially the CPVC valves!