Minecraft wiki entry for Note_Block, associated text: When a note block is powered by a button on its side, it does play a note, but is often difficult to hear because the sound of the button can overlap the note block.
Because note blocks need space above them, note blocks powered by pressure plates or redstone directly above them do not make a sound.