At least four people have been killed and many other crew kidnapped after Houthi rebels sank a cargo ship in the Red Sea, authorities say.