An ideal escape for an August weekend, Castle Hill Inn offers some of the Narragansett Bay’s best dining and unbeatable views.