If the proxy does rewrite the hostname header this will probably cause a redirect loop. Configure the DNS to route requests for the hostname to your proxy service. Consider restricting access to your Managed Web Site to the IP address used by your proxy service, and possibly one or two other addresses for troubleshooting, to prevent people bypassing your proxy and accessing the site directly.