We have a few bears and mountain lions and I'm sure they get a drink too, but I have not spotted them drinking.
The biggest visitors are possums and skunks but they can't reach the water, it's up high and has these plastic balls that float above the opening where the water is... they have to be pushed down to access the water and the smaller animals can't make it work.