[stable/2023.1] upgrade mcapi, k8s collection and capo version (#2157)

This is an automated cherry-pick of #2150
/assign mnaser

Reviewed-by: Mohammed Naser <mnaser@vexxhost.com>
diff --git a/images/magnum/Dockerfile b/images/magnum/Dockerfile
index 756a6f7..864f75c 100644
--- a/images/magnum/Dockerfile
+++ b/images/magnum/Dockerfile
@@ -21,7 +21,7 @@
 pip3 install \
     --constraint /upper-constraints.txt \
         /src/magnum \
-        magnum-cluster-api==0.22.1
+        magnum-cluster-api==0.24.0
 EOF
 
 FROM registry.atmosphere.dev/library/openstack-python-runtime:${RELEASE}