Effects of non-Newtonian rheology on transition to turbulence