Supernova feedback in an inhomogeneous interstellar medium