The name of the tune is "Slane." The religious lyrics I'm familiar with are "Be Thou My Vision" and "Lord of All Hopefulness." Click here for a thread with lyrics to these hymns, plus "Banks of the Bann," which has almost the same tune.
-Joe Offer-