Hiya,
Id say it depends on how noise sensitive you are...I personally wouldnt, if I did I would run it with the skimmer and fans (and vortech/chiller if you plan on getting one) off when sleeping.
I just turned them of on my tank and there is virtually no sound.
Also I know on hot days...