Generally, you will want to use the DNS name. If you have a one to one static nat (not using ports), and are inspecting DNS it will translate the response to the private IP address.
If you are using a router, I suppose you might be able to get fancy with NAT on a Stick, but I don't think you will find a solution in the ASA/Pix.