In my experience bottled water is given if you ask for it (on shorter flights). On longer regional flights (like CGK, particularly on red eyes), they'd usually distribute it...

There was this one time when Himalayan bottled water was given out, which took me by surprise... must have been a leftover from a flight from India.