A Status Yellow rain warning for several counties has expired, as Kerry County Council reported "torrential downpours" and flooding in parts of the county.