Stephen Myler landed an injury-time penalty to give Northampton a winning start to their Champions Cup campaign in a 16-14 victory over Montpellier at Franklin's Gardens.