Metro Mayor Steve Rotheram said the move "cements our place as one of the leading regions in the UK"