A former waste management site in South Tyneside is set to be transformed into a huge new logistics base.