A family beach house on the Isle of Palms was transformed into a forever home when life took an unexpected turn