Design and engineering of an oil or gas pipeline would probably be mechanical (pumps, compressors, pipe, etc.) with perhaps some civil (actually installing the pipeline). Petroleum engineering has more to do with reservoirs, exploration and production rather than pipelines per se. Chemical engineering is more about refineries and petrochemical plants.
As far as where to go, I would assume that schools in states where the oil & gas industry is important would have good programs, internships and placement. Without specialized knowledge in the quality of programs, I would first look at UT Austin, Texas A&M, LSU, possibly Colorado School of Mines, etc.