Sounds more like a DNS issue than an Apache issue. By default, if enabled, Apache can host user content in a user's public_html folder (/home/username/public_html/), through the URL "/~username/". If you also setup DNS mappings, and probably add some extra Apache config, you can get the subdomain names too (username.outpost2.net). Of course, this means there is a Unix user account on that machine to host the files from.
I don't know about the DNS stuff, but maybe some of the Apache stuff could be done.