A Sheffield antiques shop is to be demolished after flooding breached a defence wall.