The MUSE Hubble Ultra Deep Field Survey. VI. The faint-end of the Ly alpha luminosity function at 2.91 < z < 6.64 and implications for reionisation