Evidence for supernova feedback sustaining gas turbulence in nearby star-forming galaxies