Request a live demoof the Acquia platform
We've been thinking about the exact same kind of setup...
Yeah, a Git hook combined with something like Apache
VirtualDocumentRoot is probably the way to go. (The latter is key,
since it means you just need to create a directory in the filesystem
with the code in it and Apache should automatically start serving the
new copy of the site from there.)
More information about text formats