These three pages will show you demo of three options available in Google Custom search Engine. For understanding the various options available you need to test in yourself. These pages will give an idea of hosting options.
1. Google Hosted - Search result will hosted on Google
2. Iframe - Result will be hosted on your space
3. Search Element - Get search term input box and result at same page without page refresh