Nice Map is a WMS client for Drupal. It comes with views module support and should work with latitude/longitude data stored by location module, or basic cck number fields.