Ripon councillor immediately resigns from new committee