A pub that has stood derelict for the last ten years is set to finally be demolished and turned into homes.