A hotel which had to close following extensive flooding five years ago will reopen today following an almost €5m investment.