Generally, heavy gauge multiple-strand bare copper is used. In newer homes, most water supply is copper with soldered joints. This is even used by licensed electricians following local code and subject to inspection. In any case, the good point made is to either have a locally licensed electrician do the work or know your local code and have it inspected.
