Using my host's DNS for my website, and my provider's for myself... Never cared much about OpenDNS (although I did consider using it, I really never had noticeable problems with my default DNS.)
Never heard of Google Public DNS. I'm not sure I would want them to be aware of EVERY SINGLE of my website requests, though... "Oh, we're only offering this service because we don't know what to do with our gazillion dollars..." Yeah, and I'm the queen of England.