Something like this? tikz-cd allows you to use glyphs for arrow tips. (I had to define a slightly wider version in order to avoid the symbol from being clipped.)
\documentclass{article}
\usepackage{tikz-cd}
\makeatletter
\pgfdeclarearrow{
name=xGlyph,
cache=false,
bending mode=none,
parameters={\tikzcd@glyph@len,\tikzcd@glyph@shorten},
setup code={%
\pgfarrowssettipend{\tikzcd@glyph@len\advance\pgf@x by\tikzcd@glyph@shorten}},
defaults={
glyph axis=axis_height,
glyph length=+1.55ex,
glyph shorten=+-0.1ex},
drawing code={%
\pgfpathrectangle{\pgfpoint{+0pt}{+-1.5ex}}{\pgfpoint{+\tikzcd@glyph@len}{+3ex}}%
\pgfusepathqclip%
\pgftransformxshift{+\tikzcd@glyph@len}%
\pgftransformyshift{+-\tikzcd@glyph@axis}%
\pgftext[right,base]{\tikzcd@glyph}}}
\makeatother
\tikzset{
supset/.tip={xGlyph[glyph math command=supset,
glyph axis=5.2pt]},
}
\begin{document}
\[\begin{tikzcd}
A \arrow[supset-latex,d]\\
B \\
\end{tikzcd}\]
\end{document}

Maximal zoom under preview on a Mac:

Alternatively you can use \pgfdeclarearrow to declare the arrow.
\documentclass[tikz,border=3mm]{standalone}
\usetikzlibrary{arrows.meta}
\pgfdeclarearrow{
name = shook,
parameters = {\the\pgfarrowlength,\the\pgfarrowwidth},
setup code = {
% The different end values:
\pgfarrowssettipend{\pgfarrowlength}
\pgfarrowssetlineend{.01\pgfarrowlength}
\pgfarrowssetvisualbackend{-.1\pgfarrowlength}
\pgfarrowssetbackend{-.25\pgfarrowlength}
% The hull
\pgfarrowshullpoint{\pgfarrowlength}{0pt}
\pgfarrowshullpoint{0pt}{-\pgfarrowwidth}
\pgfarrowssavethe\pgfarrowlength
},
drawing code = {
\pgfpathmoveto{\pgfqpoint{0pt}{0pt}}
\pgfpatharc{90}{-90}{\pgfarrowlength and \pgfarrowwidth/2}
\pgfpathlineto{\pgfpoint{-\pgfarrowlength}{-\pgfarrowwidth}}
\pgfusepathqstroke
},
defaults = { length = 4pt,width=8pt}
}
\begin{document}
\begin{tikzpicture}
\draw [shook-latex] (0,0) -- (0,-2);
\draw [{shook[length=3pt]}-latex] (1,0) -- (1,-2);
\draw [thick,{shook[length=3pt,width=7pt]}-latex] (2,0) -- (2,-2);
\end{tikzpicture}
\end{document}

supsetbyglyph length=1.5ex. What about the second code? – Nov 01 '19 at 05:10glyph length=1.5exchange the size in both dim x and y in properly way. – Nov 01 '19 at 05:16r,l. – Nov 01 '19 at 05:26\[\begin{tikzcd} A \arrow[supset-latex,d] \arrow[supset-latex,r] & C\\ B & D\\ \end{tikzcd}\]. – Nov 01 '19 at 05:27