Robert Tannahill (1774–1810), Poet