CartoView - SF Social
CartoView has released the source code for a number of Google Map templates.
This Google Map of San Francisco includes Fusion Tables, Twitter, Flickr and You Tube layers. The map lets you view layers that display San Francisco parks, events, Tweets and videos directly on the map.
If you want to create a similar map for your own town you can download the source code and adapt the map to your own purposes. The source code for the map and for a number of other Google Maps templates is available from the CartoView Demos page.