I don't think that it is relevant at all that this is a former council house.
Your dad owns the house. He just has a mortgage of €2,000.
When he dies, the executor of his will should pay the €2,000 and any other debts he has and then distribute the assets.
If it's not relevant that it's a council house, it's not relevant that you are a tenant.
This is a legal and medical issue. If your father has periods of dementia and periods of lucidity, for want of a better word, the solicitor would have to take exceptional steps to make sure that he was mentally fit to make a will. His solicitor would know the procedure.
If your father wants to give you the house and
If one or more of your siblings know and agree with this...
Maybe ask one of them to bring your father to the solicitor.
Alternatively, if he has a friend who could do this.
Of course, it's even better again, if your father could go to the solicitor on his own.
It always looks bad if the beneficiary brings the father to the solicitor.
Brendan