I believe this has already been suggested a while back (for the record, though, it didn’t show up when I searched “aquarium”).
In any case, if fishing ever gets implemented, this needs to become a reality. Even if fishing doesn’t, this would be fun to have.