Get the Classic water bottles (the red topped ones).
Most pet shops and online retailrs stock these. They come with a white wire attachment or you can buy one of those Ferplast bottle holders that clips onto barred cages. Savic also make them. If you use a tank style cage, they can fit through the spout hole and be attached by the wire through the holes already in the perspex.