Want to change location of overridden template file

I want to override a template file, content_profile-display-view.tpl.php, that comes with the content profile module. However I don't want to place the new content_profile-display-view.tpl.php file in my themes root folder as is the normal method for overriding a template file. I want to place it in a custom module.

So what function will I use in my custom module to make drupal look in the correct place for content_profile-display-view.tpl.php?

If I've made that sound alot more convoluted than it sounds basically - drupal looks for overridden template files in
drupal\sites\all\themes\mytheme

I want it to look in
drupal\sites\all\modules\mymodule