It's located in the Haunted Castle and you can only use it at night. As well as getting the God's Chalice, you'll also get a Hallowed Essence, $100,000, 1,000 bone fragments, and "The Devil's Luck" title. You can only pray at the gravestone once per night. Looting a chest....