Do you have any friends that have any handguns? If so, then you might want to try and shoot what ever they have. If not, some ranges rent different pistols, your choice of make and caliber. Try several.
As far as CCW goes, a semi-auto is a little more comfortable (thinner) to conceal than a revolver. Revolvers are a bit bulkier in my opinion. Now remember, these are just (MY opinions)....
When I first joined the dept. back in 86', I carried a Smith and Wesson .357, model 586 in nickel with a green ramp. Awesome weapon, still love it, but it was a bit bulky for me as a ccw, but that is what our Chief at the time allowed us to carry... for some reason, he was against semi-auto's.
Now, we carry semi's. I choose to carry a Springfield XD .40 service model for Duty and for ccw.
I've carried glocks in the past, but didn't like them, they didn't fit my hand right. Now that was the glock 22 in a .40 cal.
My Wife ccw a glock 23 which is a little bit smaller .40 cal. than the glock 22, and I have to agree with her, it is a NICE pistol, but I would still take an XD over it.
You and your wife need to go to your local gun store, ask to see several types of guns, explain to them what you want it for. They will be very helpful in trying to fit you to a good gun that will last a long time with proper care.
Don't go "CHEAP".... you will regret it... If money is an issue, then ask if they have lay-a-way. Most gun stores do, usually 90 days or so, and if you cant pay within that time, then talk to them and they will work it out with you, but don't go cheap....
I would go with a glock or Springfield XD. NO smaller than a 9mm, but .40 is better....
Good luck.