Those stock tanks are meant to hold water. They are made of thick plastic and last several years even out in the sun. Many pond liners are made of HDPE or PVC
plastic as well, although firestone makes high quality rubber ones as well (called EPDM), but they do cost significantly more.
You may find one at some other kind of hardware type store or feed store nearby, it's just going to take some digging around.