With its stunning views of the Charleston Harbor and iconic Pineapple Fountain, Waterfront Park offers a picturesque setting for a memorable proposal.