If the mattress is going to be used for more than a couple of days straight, get one with an internal pump. It will certainly lose air over time, and it’s much more convenient if you can just push a button to air it up.
Don’t automatically assume a new air mattress is leaking air. Most any inflatable mattress will need some additional pumping up the first few nights; it’s not leaking air, it is stretching out the material. It takes two or three nights of sleeping on it to stretch the material to its final dimensions.