Water fountain for dogs and cats