Multi-layer composite pipe