Size matters!

I am definitely NOT an expert, but I think PVC is the cheapest and easiest to work with in the smaller sizes. The rules change as the pipe diameter gets larger.

Can you post your expected diameter and run length? You might then get some expert advice.

If you post your actual overflow design, then somebody might even have a good suggestion to save you money and/or time.