Hi welcome to the forum from North Central Texas - I think you'll like it.
There are several "snubby" revolvers available, but I'm not a expert on those so I'll let some others advise you on those.
But I'd suggest you consider a small auto too and then get the one you want.
There are several .380 cal. mouse guns that do a great job and yet are like feathers to carry - you can look at :
Sig - Model #P230 Cal. .380 - not a mouse gun, but close.
Walther - Model #PPK/S Cal.380 - not a mouse gun, but close.
Kahr - Model P380
Kel-Tec - Model P3AT Cal. 380
Ruger - model LCP - Cal. 380
Colt Mustang - used
But if your more comfortable with a revolver, that's what you should get.
A friend of mine carries the Ruger LCR and likes it.