Properly proportioned and mixed concrete is water tight. No admixtures are needed.
Do not use less than a 6 sack mix. In public works, for water reservoirs we use concrete without admixtures regularly.
Stan Scholl, PE
Laguna Beach, CA