Scottish comedian Janey Godley has died aged 63 after receiving palliative treatment for terminal cancer, her management company has confirmed.