The best type of pipe for plumbing depends on your needs and concerns. For example:
PVC lasts indefinitely and is easy to install.
PEX is easy to install and isn’t subject to corrosion.
Copper is durable and slightly more expensive.
Talk to your plumber about all your options, which may include other types of pipes (CPVC, polyethylene, ABS, polybutylene, etc.)