generally, if you are doing outdoor piping (pipe exposed to sunlight) pvc is not suitable as it is prone to damage by UV. indoor is ok.

all purpose pipe, HDPE or ABS would be a good choice.

do note that if your pipe system is pressurized (have a pump); syabas would only approve of pipe made out of polysteel, copper, or stainless steel pipe.