Esteemed scientist led pioneering research into psychoactive substance, with findings that helped ease its entry out of counterculture and into the mainstream