Canon makes AC adaptors for their cameras, and you can get generic equivalents for about half price on Ebay, etc. But if you're going to be out and about, you would need to buy or build a power supply that draws off some larger battery source, like a car battery, or external pack of D cells or whatever. And you would need the right connector for the power jack on the camera. Or, of course you could just replace the regular batteries every few hours.
In one of my tests, the camera did ultimately shut down while the script was running. It retracted the lens and shut down in the normal manner when the batteries got too low. No apparent harm to the camera or the SD card.
The A590 has 640x480, but the next one up is 1600x1200. Other models may have choices in between.
I think Fudgey may be right about there being a limit to how many exposures these cameras can really deal with at one time. After one of my timelapse tests, I powered up the camera in playback mode when there were almost 3000 pictures on the SD card. It just kinda sat there churning, presumably trying to set up a table of all the pictures on the card. Anyway, it may make sense to use 4GB cards and replace them more often instead of a 16GB card. And you would want to reset the filename counter too as he suggests.
If it's a critical session that you can't repeat, you definitely want to do a full test run with the camera, batteries, memory cards, etc., to make sure it's going to work. This is particularly true if you will be using continuous power and very large SD cards.