Surfactant system for water-based well fluids