Middleware to handle Exceptions and return appropriate status code

[iainsproat]

We currently handle exceptions in multiple different locations. Our HTTP error status codes are returned in an inconsistent manner from multiple different points.
We should standardise error handling through the use of middleware.
We should return appropriate Exceptions, tailored to the underlying cause, which the middleware captures and converts to the appropriate HTTP status code.