South Africa has safe and high quality tap water in cities and towns, however less so in rural areas. However, even in more remote areas, accommodation establishments can advise you further with, in most cases, tap water being safe to drink.
Cholera vaccination is not required unless you will be working/volunteering for long periods in rural areas with unreliable drinking water.
Water purification tablets, boiling tap water and bottled water are other precautions travellers can take if unsure about water situations in less populated areas.