A second union has voted in favour of a revised pay offer from the body that represents all Scottish councils.