Then if you want to go the custom field route, you’d be able to load the blog post the image is attached to using $post->post_parent e.g.
<?php echo get_post_meta($post->post_parent, "site_url", true); ?>
Clarification: Do you want the image to link back to the front page, or to the specific blog post that the image is attached to?
