I would also recommend an AGM, and I agree with the general sentiment to stay away from Optima spiral type AGMs. If a flooded lead cell is deep discharged a couple times it will be basically shot*. AGMs are more resistant to deep discharging.
It is possible to keep a battery charger connected 24/7 without ruining the battery, it just has to apply the proper float voltage, then periodically apply a higher charging voltage similar to the approach above with the lamp timer. I have a charger in my camper that is plugged in most of the time. It is programmed to float at the voltage specified in the battery instruction manual. Gel, AGM, and flooded batteries all prefer a slightly different float voltage. I have a CTEK smart charger that can be connected 24/7 as well without ruining the battery. It includes modes for flooded, gel, and AGM batteries and will output the proper float voltage and then attempt a charge a few times a day. Noco also makes smart chargers, although I don't know the details of them as well as the CTEK. There are smart battery tenders available with 1-2 amp ratings. My CTEK smart charger is rated at 7 amps - I can leave it on a lawn mower or something all winter as a tender if desired, or it will charge a common auto battery overnight. Higher powered smart chargers (10A, 40A, etc) are available, however the price goes up quickly. The old style chargers with a voltage selector and a timer will still work, but they'll never get the optimal charge level on the battery, they'll always be over or under. The only use I have for the old timer type chargers is for the cranking assist mode if another vehicle is not available to jump start something.
As batteries in my vehicles need replaced I have been changing them to AGM (not Optima brand) to get the benefit of increased resistance to deep discharging as well as a flatter temperature vs cranking amp relationship. The best AGM I have found from a technical standpoint is Lifeline, but they are not readily available a lot of places. If you need a deep cycle and can wait a couple weeks they're worth a look. I use whatever non-Optima AGM is handy for my vehicles, which has included the Enersys Northstar and Deka/East Penn under a couple different brand labels.
*There are some reports of using a constant current charger to bring flooded cells back from the dead but I have not personally tried it. There is a significant hazard of overheating the battery, so I would be hesitant to start a multi-day constant current recovery procedure without a power source that can monitor the battery temperature and shut off the charger if the battery overheats. I maintain a large fleet of batteries at work, but ours have protection built in to disconnect the battery when it gets down to 1.75 V/cell, so I'm not experienced trying to recover deeply discharged jars.
Sent from my Pixel 2 using Tapatalk