Council leaders in the North East have signed a 'trailblazer' devolution deal.