I think cloud zoomCloud Zoom should work. It's what's used on a lot of fashion magazine-style websites. Here is an excerpt about it from the module's project page:
... integrates the Cloud Zoom JQuery addon with CCK ImageField and ImageCache (or Drupal 7's core Image module).
http://drupal.org/project/cloud_zoom This addon provides a small, thumbnail sized image, with an on-hover popup, zoomed and centred on a larger version of the image.
