We use a mysql database and javascript display, examples at:
These use a location list in mysql – it works esp good with wordpress, joomla or Drupal since those all use mysql and the map table can be in the same database. The javascript uses the google map api to place pins on the map and define text, and optional links for more information.
The data table can be updated as needed, for regularly updates, like the weekly art events, we use a script to get the latest info and lookup the lat/long of the address.