French President Francois Hollande has been honoured at a lavish White House state dinner, capping a visit to the US aimed at renewing the partnership between the two long-standing allies.