Disallow consuming segment deletion

Recently we had an incident that some consuming segments were deleted by an operator by mistake. Now that pause/resume are in place, there's no use case for intentionally deleting a consuming segment. In this task, the segment DELETE endpoint needs to be modified to check if the provided segment name is a consuming segment and if so, fail the request with proper error message.