The 'I Will Always Love You' singer’s death was announced by her nephew, with her reps later confirming that she died following a 'brief battle' with cancer