A prominent site in Morpeth will be turned into housing if plans submitted to Northumberland County Council get the green light.