Yorktown Countdown. If you want to welcome the New Year overlooking the scenic nightscapes of Charleston Harbor, head to Patriot’s Point, which is a few minutes away from downtown. Yorktown Countdown takes place aboard the USS Yorktown, a huge retired war vessel. The unique NYE experience features three stages, live music, a full-service bar …