A huge hotel that has remained empty for more than two years is set to fling open its doors with a 'grand opening' later this month.