A Maurice Shanahan goal in the second half of additional time set Waterford on their way to a historic and captivating championship victory over Kilkenny in Thurles.