Atomic‐Level Reactive Sites for Semiconductor‐Based Photocatalytic CO2 Reduction