Thousands of people are expected to visit Sullivan’s Island this weekend as the Lowcountry celebrates Carolina Day.