The Lothric Knight Greatsword, Dragonslayer Swordspear, Dragonslayer Spear, etc. are good options that deal lightning damage.