You need a specific bottle of water, from the kitchen (on one of the northern tables, IIRC). When you pick it up your quest log will be updated (the quest icon will turn red) and you will be able to give him the water through a speech option.
It would have made more sense if the prisoner would accept any water, or the quest was changed to retrieving some kind of medicine, which could be unique.
Welcome to the forum. <img src="/ubbthreads/images/graemlins/wave.gif" alt="" />