A multi-million-pound redevelopment of a flattened pub has finally been completed more than two decades after the boozer’s closure.