A government minister has insisted the Northern Powerhouse is a ‘story of success’, just days after a damning report into the devolution project.