I took my son shooting almost every day and I kept him involved with the cleaning, take down, safety checks, etc. and he never developed the infatuation that some kids get for guns. If he wants to go shooting then I take him shooting. I was raised with the idea that guns were something taboo, and mom made dad keep all the guns hid. I was not a bad kid, but I knew and had shot every one of dads guns when he was away, and one time I shot a hole in the livingroom floor. I think he took me shooting two or three times as a kid. My advice is keep guns safe, but do not treat them any different from any other tool that can potentially kill someone if used improperly.
What you can do if you have a night stand is take the top drawer out and make a little platform out of masonite between it and the lower drawer. Don't tell your child about this spot.