A ship earlier attacked by Yemen's Houthi rebels has sunk in the Red Sea after days of taking on water, officials say