The majority of Cork county councillors are in favour of the controversial merger of the city and county councils.