There’s amenity=watering_place, that is meant for places intended for animals to drink. I’m not sure if we have an established practice for combined features like the one you show though, the amenity tag would be in conflict with the one for humans.
Maybe map as two nodes?