South Africa's national state of disaster, in place for more than two years in response to COVID-19, will end from midnight local time on Monday, President Cyril Ramaphosa said.