For our Wisconsinites on the forum the OP is reffering to "bubblers".
I knew every park, forest preserve, gas station with drinking fountains on my cycling routes. But its been years since I could depend on those.
Forest Preserves used to have wells with a hand pump. It was a good work out just filling your bottle. And sometimes I'd question the drinkability of some of them. In the city of Chicago parks would have drinking fountains running constantly. "Old time" gas stations, especially Clark stations had refrigerated water fountains. Those were the best. But I can remember filling up in the service area of gas stations. Usually a filthy utility sink. But that saved the day on many occasions.