This question is not uncommon, i.e., "which gun for both CCW and HD?"
It's worth noting, as always, that the question isn't reasonable. Same as asking, "I'd like a pickup truck or minivan that's also good for fast handling on twisting mountain roads."
You're talking about two different kinds of weapons, such that the better one is for one task, the worse it will be for the other. If you want to straddle the difference, you'll wind up with a gun that isn't optimum for either duty.
Depending on your job, the city you live in, your lifestyle, etc., your need for one or the other will be more pressing. For HD, you can shop around and get a decent shotgun for around $200 or so. That's major firepower. Then you can focus on getting a solid carry gun and not compromise on any front.
Later, as finances allow, you can get a big .357 or similar for HD, too.
The Ruger SR9c is a possibility for the application you're looking for here. It conceals well, has a superb trigger, and is extremely accurate and reliable. Load with the 10-rd mag for carry, with the 17-rd mag for HD.