A Leigh pub dating back to the 1800s that has been boarded up for seven years is set to be transformed into a 15-room luxury hotel complete with restaurant and bar.