to paint the outside of the tank pretty much anything can be used (except emulsion, for obvious reasons)
if you wish to paint the inside then you will need a Two-part epoxy paint for potable water tanks
(NSF 61/USDA/ANSI/AWWA and FDA certified and approved).