Whoever owns the camera presumably has an interest in reducing/solving crime in the area (why else have cameras?), so they would likely be happy to make the footage available to police if asked nicely, with no warrant required.