Councillors back plans for residential schemes in Ripon