Experimental observation of the transition between hose and self-modulation instability regimes