The best long term value can be obtained from using pressure treated lumber. You can stain or paint this material and still get the look you want....

Most plumbing repairs can be done by the home owner.  A few questions in the right place can get you a wealth of information on how to do it....