What is the best pipe material for water supply?

Can you please tell me what is the best available pipe material to be used for a water supply network? We are using concrete pipeline for water supply in our area where we have a dry climate. What would be the Environmental impact on these concrete pipes after some years?  Your suggestions would be of help for us to plan the necessary maintenance procedures.  Thank you.