Dilation theory and continuous tensor product systems of Hilbert modules