Please please- Do you know this place

I have a dream......... OK, kinda dramatic, but I am hoping someone would be so kind as to share where this place is. It is cool in August--- has water very close by--- and possibly a nice little go...