The Eternal Wall of Answered Prayer will be twice the height of Angel of the North, and seen by more than 500,000 every day. Alex Ross speaks to the man behind it – and the donor who spent £30m to make this ambitious plan a reality