I very much doubt we shall ever see the reopening of the Burney Arms. The building is now in a very poor state of repair, and a great amount of money would be required to restore it. Especially given the difficulty of access!
I remember a number of years ago that CAMRA tried to buy it at an asking price of £250,000 by selling stakeholder shares at £500 a pop! Unfortunately, as my memory serves me, they were only able to raise £2,500!