PepsicCo's global chief marketing officer is quitting the group after 18 years to join household-products firm SC Johnson.