Unfortunately, for Minecraft Java Edition, there are no skins that will automatically incorporate a cape. However, in Bedrock Edition, there are some skin packs that come with capes included.

To get the Minecraft anniversary creeper cape on Java Edition, players needs to visit official 15th anniversary page on Minecraft website and scroll down to find the option to claim creeper cape ...

Minecraft fans can celebrate the release of the upcoming Minecraft Movie by claiming the limited-edition Menace and Home Capes.