In order to estimate the potential revenue from a tax of the nature outlined in this question it would first be necessary to identify the net worth of Irish households at an individual level. I am informed by the Revenue Commissioners that they currently have no statistical basis for compiling estimates in relation to such a tax. Although an individual's assets and liabilities are declared to the Revenue in a number of specific circumstances (for example, after a death), this information is not a complete measure of financial assets in the State, nor is it recorded in a manner that would allow analysis of the implications of an overarching wealth based tax.
The Central Bank’s Quarterly Financial Accounts for Q4 2022 (published 5 May 2023) does contain an overall household net wealth figure, but not the breakdowns requested by the Deputy.
The CSO published their Household Finance and Consumption Survey 2020 in May 2022 (this survey has been carried out three times, with 2020 being the most recent of those). It has a median household net wealth figure and also provides a breakdown by income deciles, though again not the breakdown requested by the Deputy.
Therefore I cannot provide the estimated yield from a tax of the nature outlined in this question.