You're probably thinking of a place like Cantler's, a short somewhat scenic drive, but with parking issues (best approached by boat). Downtown, Phillip's offers perhaps the only water view, of the many restaurants.
Going south, there is Yellowfin on Rt. 2 with great water view, or Mike's on Riva Rd. If you're thinking of driving a bit more, Pirate's Cove in Galesville, or our usual place, Skipper's Pier in Deale. The latter two offer the best chance of a group shot in the parking lot.
Cantler's and Philip's are probably the priciest.
FWIW, best crab cakes are at the Edgewater Restaurant on Mayo Rd, with zero view and zero ambiance; takeout is recommended, with a a seasonal water view from our house.