Plans for a historic devolution deal for the North East of England have received widespread support from residents across the region.