Scottish council workers vote on new pay offer