Switch astropy.coordinates UnitsError to use astropy.units UnitsException  

As discussed in #807. 

Note: After this gets merged, we can rename `UnitsException` to `UnitsError` and change it all back :)