If I got your question right,the instructions for that are in the link below:
http://www.google.com/support/sites/bin/answer.py?hl=en-GB&answer=99448
You just need a registered domain,not a hosted site and you need to have access to the domain settings panel to change the CNAME record.
Regards