The statue, believed to depict the legendary Pharaoh Ramses II, measure 8 meters long, and was submerged in ground water