A Kerry fan who travelled to Dublin for the All-Ireland football final drowned after a night out with friends, an inquest heard.