Thank you so much. Could you please elaborate about the two hand crossbows? Somehow, this is the first time I've heard of it.
You can dual wield hand crossbows as bard. They are pretty versatile and you can use your bonus action for that (since you don't use your bardic inspiration for anything but flourishes). You can take feats to help you with that, like crossbow expert or dual wield and there is gear that lets you you add your ability modifier to offline attacks.
You get your first handcrossbow with character creation and one of the first two merchants, you will meet, has another one (if not directly, look after every long rest).
Edit: you get a pretty great hand crossbow in act 2, after defeating a certain character and that can be used until the end of the game.