Missing woman captured on CCTV footage