My experience so far with my 13" MacBook Air (mid-2011) with an Intel Core i5-2557M running at 1.7 GHz, 4 GB of RAM and 256 GB Samsung SSD drive is that it will be noisy... if you pull the trigger demanding intensive tasks.
When using it doing common tasks, browsing the web, using office tools and so on, it will be running around 45º-50º Celsius (113-122 Fahrenheit) and the fan will spin at 2000 rpm with no noticeable noise.
Playing a simple YouTube video was a pain before, but now I'm using the latest Mountain Lion Developer's Preview 4 (Update 1) with the new Safari 6 and the latest Adobe Flash Player plug-in 11.3.300.257 and the temperature will rise just a few degrees and the fan will be still spinning at 2000 rpm. A huge improvement in comfort while browsing the web.
Try any intensive task, such encoding a video and the temperature will rise up to 94º celsius - 201 Fahrenheit and you will begin to listen the exhausting system and feeling hot over your lap.
Until it reaches 3000 rpm it is still unnoticeable, but if you mantain the activity, it will go up and after 4000 rpm it will noticeable. Push it more time and it will spin faster, reaching 6500 rpm and it will be really noisy.
It just depends on what you do with your MacBook Air. It can be dead quiet or disturbingly noise.

When using it doing common tasks, browsing the web, using office tools and so on, it will be running around 45º-50º Celsius (113-122 Fahrenheit) and the fan will spin at 2000 rpm with no noticeable noise.
Playing a simple YouTube video was a pain before, but now I'm using the latest Mountain Lion Developer's Preview 4 (Update 1) with the new Safari 6 and the latest Adobe Flash Player plug-in 11.3.300.257 and the temperature will rise just a few degrees and the fan will be still spinning at 2000 rpm. A huge improvement in comfort while browsing the web.
Try any intensive task, such encoding a video and the temperature will rise up to 94º celsius - 201 Fahrenheit and you will begin to listen the exhausting system and feeling hot over your lap.
Until it reaches 3000 rpm it is still unnoticeable, but if you mantain the activity, it will go up and after 4000 rpm it will noticeable. Push it more time and it will spin faster, reaching 6500 rpm and it will be really noisy.
It just depends on what you do with your MacBook Air. It can be dead quiet or disturbingly noise.