Non-Inertial Rotational Diffusion in External Potentials: Applications to Orientational Relaxation of Molecules in Fluids and Liquid Crystals