Visualise 3d Water Pipe

Hi there,

I would like to visualise a water pipe from qgis as a 3d pipe with certain diameter and conditioning colouring and to be buried 2m below the terrain. I want to click at the pipe and open the associated assessment reports. Where should I start? Is Ion the best place? Cheers,Petros