Long term solution sought over Ballymote River floods