Crossover from anomalous to normal diffusion: truncated power-law noise correlations and applications to dynamics in lipid bilayers