WeWork co-founder Adam Neumann has agreed to resign as chief executive of the U.S. office-sharing company but will remain as non-executive chairman, bowing to pressure from some of his investors, people familiar with the matter said on Tuesday.