KM3NeT Core Collapse Supernovae observation program in standalone and multi-messenger modes