Antrim has been awarded the dubious honour of the worst place to live in the North, according to a new book.