My tip is to wrap your bottle in kitchen paper and keep it wet. It doesn't matter what you use, just keep it wet and the water will stay cool even in the hottest climate.
If that's too much for you, then a pump-action thermos filled with white wine and sprite that have been kept in the fridge over night will keep even the grumpiest grandads happy.

