For information on how to activate it for your website here, please see this wiki article: http://x10hosting.com/wiki/How_to_Use_Your_Own_Domain
As for where to get it, there's a lot of domain registrars out there, namecheap.com being one of many (I do not personally have experience from them...