A damaged chemical ship, stranded off the south west coast since Wednesday, has been towed in to Cork Harbour.