A cistern is a container for holding liquids, often times used to collect rain water, for example. There is no antonym (direct opposite) for the word that describes this object, per se.
Just in case you meant to ask about synonyms instead, synonyms might include: Barrel, urn, or basin.
Just in case you meant to ask about synonyms instead, synonyms might include: Barrel, urn, or basin.