For stealth characters, higher damage bows like the Dragonbone, Daedric, and Nightingale bows are preferred, as they give you a greater chance of taking characters out in one hit from stealth and remaining undetected.
This specific type of crossbow is available to craft or buy after finding the schematic in one of the sis "Ancient Technology" quests.