Elevation data for settlements

Here is a solution using SRTM Data:

First, install SRTM-Downloader Plugin for QGIS and create an account for "Earthdata Login" at https://urs.earthdata.nasa.gov//users/new

Start the Plugin, choose your desired extent and click "Download":

Once the process is finished, merge them to one big raster, you can join your points with. Go to "Raster -> Miscellaneous -> Build virtual raster". Select all just downloaded rasters as input and unselect "Place each input into a separate band". Then hit "Run":

Dont worry if it takes some time to load/display the virtual raster, this may take some time depending on its size. Now run "Sample raster values" from processing toolbox. Choose your villages as input and your virtual raster as raster. Add a column name:

Done: