New hotel to open in the Northern Cape