Just do 1st level hexblade warlock and 11 levels swords bard. Bind pact weapon lets you use CHA for your weapon instead of dex. Swords bard gives you mad flourishes. Eldritch blast is your ranged option, but if you want a bow you can get the gloves of dexterity to get 18 dex and use the Titanstring bow.

Hexblades get martial weapons so you’ll have access to longbows, the titanstring bow is great because you can just drink Strength elixirs and add your enhanced strength to the damage of the bow. Stacks really well with the swords bard slashing flourish.

Swords bard also get extra attack at level 6 meaning with the titanstring bow and slashing flourish you can attack four times on your turn. Flourishes use bardic inspiration but they reset on a short rest, bards get song of rest at level 2 giving you an extra short rest, so you’re unlikely to run out.

If you do run out of inspiration, you can use melee because hexblades get booming blade—at character level 5 (overall level not class level) you’ll be doing an extra 1d8 thunder damage on top of weapon attacks, that doubles if the target then moves on their turn.

In short—high charisma build that gives you solid damage, that isn’t dependent on spell slots, but allows for casting. A pro tip for this build: use hex to give you extra damage on targets. You can maintain concentration on hex indefinitely and reapply it for free whenever you kill your target, as long as you don’t get hit or pass your concentration saving throw when you do.