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