Water fountain for cats and small puppies