If I'm reading you right you set up something for the domain at dyndns or somewhere, and then you create a CNAME for the one you want to redirect.
I'm not sure how to set up httpd to run on a dynamic address so I can't help you there, but in any event you should have a ServerAlias line in the configuration so apache will know to serve the site.
Jeff