All council properties in Rotherham will be inspected to assess their condition, following a £1.3m programme approval.