A lack of exhibition space and restricted budgets dog many museums, not least Ireland’s National Museum whose African artefacts Peter Somerville-Large recalls last viewing as a schoolboy