Boston Public Library. They offer museum passes. Most MA libraries only offer 50% off the aquarium but the Boston library offers completely free admission.

And yes you would just get in line at the aquarium to redeem your ticket. Whether through city pass or library coupon. I was nervous about them running out of reservations but when I got to the window they told me I didn’t have to worry about that.