As late senator's casket lies in state at San Francisco City Hall, American president says by video that 'she was always tough, prepared, rigorous, compassionate'