Apparatus for simultaneously pushing and rotating a cleaning device carried by the leading end of a cable or an assembly of rods