The town sits on the western banks of Lough Derg and offers stunning lake views, historic buildings including St Flannan's Cathedral, and a top-rated inflatable water park