Is this a different place from Rotterdam

It's in the middle of Europoort, which is the humongous port and industrial area occupying reclaimed land in the middle of the Rhine, downstream of Rotterdam all the way to the North Sea.
See map here: https://www.openstreetmap.org/#map=12/51.8673/4.2275

This is legally all part of Rotterdam city, so yes it is "in Rotterdam". There is water on both sides, separating the refineries, docks, factories etc. from the villages on the other site of the water. It is ugly, nobody lives there and the Dutch have confined the ugliness to these artificial islands, and the villages on the other side of the water are very nice.

Getting there is not easy. No Public Transport (nobody lives there). The only links to the "mainland" are bridges.
Where are you landing? Amsterdam or Rotterdam. If Amsterdam, get a train direct from the airport to Rotterdam. From Rotterdam (station or airport), you either need a hire car, or a taxi.
You will need to find a hotel, in one of the nice villages over the water, and use hire car or taxi to get there.

It's about an hour away from Rotterdam Central station by public transport.
First you have to take the metro to Spijkenisse Centrum. Then take bus 105 or 115 (direction Rozenburg). After about 15 minutes, get out at bus stop Welplaatweg. From there it's a relatively short walk (10 minutes) to your destination.

It's probably even better to take bus 205 from Spijkenisse Centrum.
You can check out the schedule and route at this site:
https://www.connexxion.nl/dienstregeling/lijn?id=Z205

Thanks Chris!
Which village will you recommend us to take a hotel?

Thanks Michel,

If we get a hotel in Rotterdam, what do you think, how much money should we pay for it?

70-100 euros for a double room.