Escape to Rhode Island this September with quiet beaches, historic mansions, lively harbors, and island retreats perfect for weekend getaways.