Plans to transform two parcels of brownfield land in Morpeth, which were formerly part of a hospital site, into housing have been given the green light.