I'm currently in this neck of the woods (in Bavaria, Franken) and just about every big town has at least one of these wells/fountains/reservoirs. Most of them aren't as large, though. If I think of the tourist towns which are frequently visited by American and strike those already mentioned, my first guess would be Ansbach.