You can use the app's "nights and weekends" settings to turn off sounds.
Or you could turn off "sync" and "push" in the app's settings under "mail, receiving" before going on holiday / re-enable when you return.
For an Exchange account you will also want to turn off "calendar" and "contact" sync in the phone's settings -> accounts under your "AquaMail (Exchange)" account.