This public drinking water fountain is on Victoria Road in Devonport, Auckland. A customer on Google says it is open 24 hours a day and sits outside the public library.
The same customer says it is handy on hot days and a free place to refill a bottle instead of buying water.