The Grand Archives are the absolute best spot to farm Souls. On the roof are three Gold Winged Knights. Not only do they reward several thousand souls per kill, but also have a very high chance to drop Large Titanite Shards. Although rarer, they can also drop Titanite Chunks as well.