Ambient sounds are typically added via regions in the region editor. If you open the Region editor in the World menu you'll find all sorts of regions called 'Audio*'. Switch to the sound tab to see how the sounds are set up. You can duplicate an existing region and then make a small region around your house (make sure you check the override box with a high-enough priority). The CK wiki doesn't have any region information (strangely) so the best source is still the CS wiki: http://cs.elderscrolls.com/index.php/Regions#Sound_Tab. This will allow you to create sound effects based on weather and time of day.
You might also want to look into Acoustic Spaces (selectable from a drop down box when editing the cell data). They seem to be derived from region data (as described above) though I haven't had a chance to look into them yet. Alternately, you can drag AMB sound markers into your cell.