http://sites.google.com/support/bin/answer.py?hl=en&answer=99448

Log in to the site
Under "More Actions..." choose "Manage Site"
Choose the "Web Address" Option on the left nav sidebar
Add the new web address (must have a subdomain like www.)

Make the CNAME change at your registrar