Intrinsic vibrational angular momentum driven by non-adiabatic effects in non-collinear magnetic systems