Since the feature (as far as I know) started with Safari, some Apple-centric sites were early adopters, so sites like macrumors and appleinsider have it. But as far as more mainstream, one I know of is CNN, which has it for breaking news.
The Safari feature is non-standard. Firefox implements the WebPush API that Chrome also supports. So sites supporting Safari will not automatically work in Firefox.
Facebook supports it, I believe. And maybe Gmail, though that one could be Chrome-only.
GMail has notification support in Safari, but it seems to be broken currently.
Facebook Messenger too (http://www.messenger.com/), although you have to thankfully enable it in the settings.