I love Ken Rockwell, he has tons of tutorials on cameras even iPhone apps! He recommends this camera is you have less than $700 to spend. (You can get it now for $500 or less at Target.)
http://www.kenrockwell.com/nikon/d40.htm
Here is one review on it, since you are worried about weight:
The D40 is Weightless!
The first thing I noticed, and so did my non-photographer wife, is that it's so light. We thought it would be much heavier, but no! It must be made of air. It's like not having a camera with you at all.
The light weight makes it a dream to carry around all day. Having a camera with you instead of left in the car or at home is the difference between getting a great shot or missing it.
My D40 lets me get make great results hand-held at slow speeds, probably because it also has very, very little shutter and mirror vibration.
End of Ken's Review!
My Review:
I have this camera and LOVE IT!
I lug it around everywhere.
On a side note you can rent a camera body and lens online for pretty cheap for a couple weeks and take that with you! I use rentglass.com for my lenses and they are great.