Difference between the Camera album and the Local album

Local Album is the default album on your phone/tablet, it shows the photos and videos which have been downloaded to the local device. 

Camera Album refers to the album which is stored in the memory card. The Camera Album will not be shown when camera connection is off.