Devolution across the north of England could be 'transformational' and put power back into the hands of local people, said MP Jim McMahon.