Translation:Who wants to drink a bottle of green water?
The water is green. Maybe there's mold in it or something. It's likely a rhetorical question.
If it were the bottle which were green (rather than the water), I think it would be written as "Cine vrea să bea o sticlă verde de apă?" - the adjective following directly after the now it's modifying