The Cranberries vocalist, who rose to fame alongside her fellow Irishmen with songs like "Linger" and "Dreams," died at the age of 46 from drowning due to alcohol intoxication