How to display content of a link in a tooltip on hover
Beauty Tips is a drupal module and a jQuery plugin that will allow you to display content tooltip style via hover, click or a range of other events.

There is to my knowledge not built in support for loading content from different placed, but this is near trivial with the power of jQuery AJAX APIs.