Any mattress should be fine (though double check the height of the gap between the bed and trundle base with the mattress).

You can get waterproof mattress protectors to protect from accidents. I used that for my boys and they never leaked through