The Society of St Vincent de Paul is set to receive a windfall of up to €10m later this year, thanks to the generosity of a Galway publican who died in 1998.