Yes, even constant low workloads will make the fan audible.
See the NotebookCheck review of the i5:
> At around 30% CPU load (installation of OS updates), the fan is clearly audible and we are already above 40 dB(A), which is hard to understand considering the low performance level.
Weird. At any rate, it doesn't seem to be an issue that deters companies from issuing those things to employees, and looking at the Windows machines some companies issue, that's probably fine; at least it's not a gargantuan brick with a super outdated Atom CPU and Windows 7.
Reading the other comments, even some devs are happy with Airs.