This year’s Turner in January exhibition includes fabulous watercolours held by the National Gallery of Ireland in Dublin. It is a rare treat and with an exhibition by the best contemporary watercolourists opening at the RSA tomorrow, the medium is having a moment in the spotlight, writes Susan Mansfield