Scene Capture Cubes capture a fully dynamic cube map from their location on every frame. This requires a Cubemap Render Target to actually capture to, and then that Render Target can be used as a texture within any Material.
Scene Capture Cubes are quite expensive in terms of performance and should be used only when they are absolutely required to achieve a given effect.