The hole is partially concealed by several boxes and dead Cage Spiders. Upon entering the house, head right and drop through a hole in the floor.
The emblem to join the covenant can be found in the Undead Settlement, inside the leftmost house from the big open area with several peasants and an Evangelist praying at a burning tree.
