Hi LKelly. You are not the only person in the position you find yourself. I know more than one that almost exactly shares your type of situation. A farm, back-breaking, responsible, arduous, worrysome, inherited and any other adjective you wish to bring up. The future of the farm will never improve. And you become a Clerical Officer to support yourself and your family. One myth is broken here i.e. lowly civil servants are well paid for doing nothing. Furthermore, you may find yourself never chasing promotion because of the splitting of your roles (family, farm, public service). Your family will always come first and the land is land (the cause of everything bad that historically happened to Ireland). You have responsibilities as a clerical officer too.
A first for me is to recommend that you engage a good financial advisor. You're never going to make a profit from the farm. You can't give it up, you're tied to it. Therefore, you have to play the cards which have been dealt to you. I hope the loss your farm is making can be pitted against your deductable tax as a civil servant. This is where your financial advisor comes in. It will cost, but you have no choice (in my opinion).
Transfers between locations in different counties are not easy in the civil service. I have seen some in my time, but they were few.