Mechanical and Microstructural Characterisation of Cooling Pipes for the Compact Muon Solenoid Experiment at CERN