Moving textured pipe along path
This is a (straight) pipe modelled as a curve, using its native Bevel, mapped in its own UV space, deformed along its X by another spiral curve, using a Curve modifier. Translating the pipe along X with respect to the spiral's origin moves it around the spiral.

That's a lot of curves :) the straight pipe could have been a mesh.