In order to have AVIF support in Digikam in Debian, you need to install kimageformat-plugin.
$ sudo apt install qt5-avif-image-plugin kimageformat-plugins
Alternatively, similar support is offered via qt5-avif-image-plugin, but Debian recommends the kimageformat-plugin for general users.