Our medium-small city (La Crosse, Wisconsin) is known for several breweries, but a tiny village only about 30 miles away — Spring Grove, Minnesota —has an eponymous company that makes delicious flavored sodas, including unusual flavors like “rhu-berry.”
ETA: Ninja’d by post #23! Who woulda thunk it? Howdy, neighbor!
Oh, I love their blueberry soda! When I moved in Lawrence, Kansas, the amazing Mass Street Soda store carried this, and about a million other little local products from across the US (and beyond, eg. Peru’s wonderful Inka Cola). I think they might no longer be in business, alas.
I also recall a delicious melon soda from somewhere in Connecticut. (ETA — it’s “Avery’s”.)
Many mid-sized breweries in southern Germany make orange soda (which they call “lemonade” for reasons). I haven’t checked but I’m sure there’s a locally brewed soda close enough to me.