Water Views Wedding Venue (50-60 people)?

Hello! I am looking for recommendations for wedding venues with water views, and venues also allowing a smaller minimum guests of 50-60 people.

Bonus points if there is a separated space music/late bar.

We are flexible on budget and location. TYIA!