Mayor Steve Rotheram and Greater Manchester counterpart Andy Burnham have signed a landmark agreement