Cork City Council has become one of the largest local authorities to back a national campaign to make the buying of sex illegal.