if you manage to get the 20k souls required for the Key item from the blacksmith and have no quelms killing humans you can grind the human Covenant members behind the wall in the forrest, this is great because there is a bonfire near the door which they are behind, and they are all worth at least 1000 souls… most are 2000.
You can check for more methods here