First of all, welcome to the forum. While I applaud your lofty goals, only two companies have been successful in converting a petrol engine to run on diesel. Oldsmobile and Volkswagen. Both were monumental failures until the engineers re-worked the foundations of the engines to handle the stresses involved.
If you are really interested in a diesel conversion, you are starting with a good base. By far the most popular conversion, at least in Australia, was to the GM 6.2/6.5 diesel, while in your country, a straight conversion over to the 2.5 liter Rover diesel would be far more practical and maintainable as the parts are readily available in Ireland and the British Isles.
As far as driveability, the diesel is going to have a bunch more torque low down so your off the line acceleration will be much better, as will your highway acceleration as in ability to pass. I for one, prefer a diesel over a petrol engine for those reasons, plus I tow a rather large trailer and the diesel is much more suited to that task.
Having said that, technology has done a great job with the petrol engines and the difference in power and fuel efficiency has narrowed considerably in the last 10 years. Used to be you could expect at least a 20% increase in fuel efficiency over the petrol equivalent (diesel fuel contains 20% more energy by volume than gasoline) but even that is has been narrowed due to more efficient petrol engines and less BTU value in the low sulphur diesel fuel now available.
If you are doing it for the economics, you would have to put a pile of mileage on the conversion to justify the cost so use your calculator to work out if you really want to do this. If you want to do it, just because you can, than all bets are off.
If you are determined to do a conversion on your existing engine, please ship your car over here to Canada and fill the balance of the shipping container with large denomination currency. It can be done, but no guarantees on the finished product. We call it the 12/12 guarantee. 12 years or 12 feet, whichever occurs first.
Talk to your mechanic, actually take him/her out to the pub and buy him/her a beer, and get his/her take on it. From what you have said, a conversion over to the Rover diesel would make more sense as all the bits would be available.
Good luck
Bill
91 Buick Roadmaster/Avant 6.2 NA conversion (gone but not forgotten)
94 Cadillac Fleetwood (sold)
08 Aerolight 23TT
06 Vortec Max Silverado CC SB (sold)
10 Avalanche (electronic quagmire but love the truck)