There's at least one steam railway in Germany that still runs down the streets:
https://www.youtube.com/watch?v=hMonLkerBSA

The Molli, and the more famous Hartz Railway, do actually provide a local service, they're not just for tourists.